| GeneralLedgerReleaseBatch |
| EntityType | Independent |
| Logical Entity Name | GeneralLedgerReleaseBatch |
| Default Table Name | SaGLBatch |
| Logical Only | NO |
| Definition | |
| Note |
| GeneralLedgerReleaseBatch Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
GeneralLedgerReleaseBatchId |
INTEGER | NO | ||
CampusId |
INTEGER | YES | ||
| BatchNumber | CHAR(8) | NO | ||
| BeginTransactionDate | DATETIME | YES | ||
| EndTransactionDate | DATETIME | YES | ||
| Status | CHAR(1) | NO | ||
| ExportDate | DATETIME | YES | ||
| ExportFileName | VARCHAR(50) | YES | ||
| ExportUserID | INTEGER | YES | ||
| ExportType | CHAR(8) | YES | ||
| LastModifiedUserId | INTEGER | NO | ||
| CreatedDateTime | DATETIME | NO | ||
| LastModifiedDateTime | DATETIME | NO | ||
| RowVersion | TIMESTAMP/DATE | NO | ||
| GlBatchNumber | INTEGER | NO | ||
CampusGroupId |
INTEGER | YES | ||
| IsFileTransferSuccessful | BIT | YES | ||
| GlEntry | VARCHAR(25) | YES | ||
| Period | SMALLINT | YES | ||
| FiscalYear | VARCHAR(5) | YES | ||
JournalEntryGroupIdentifier |
INTEGER | YES | ||
| ExportedDateFormat | VARCHAR(20) | YES | ||
| TransactionType | INTEGER | YES | ||
| AxBatchNumber | VARCHAR(20) | YES |
| GeneralLedgerReleaseBatch Keys |
| Key Name | Key Type | Keys |
| SaGLBatch_BatchNo_N_N_IDX | Inversion Entry | BatchNumber |
| SaGLBatch_SaGLBatchID_U_C_IDX | PrimaryKey | GeneralLedgerReleaseBatchId |
| SaGLBatch_SaJournalEntryGrpId_SaGLBatchId_U_N_IDX | Alternate Key | JournalEntryGroupIdentifier, GeneralLedgerReleaseBatchId |
| SaGLBatch_SyCampusGrpID_N_N_IDX | Inversion Entry | CampusGroupId |
| GeneralLedgerReleaseBatch Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| Campus | Non-Identifying | Zero or One to Zero or More | CampusId | NO | |||
| JournalEntry | Non-Identifying | Zero or One to Zero or More | JournalEntryGroupIdentifier | NO | |||
| CampusGroup | Non-Identifying | Zero or One to Zero or More | CampusGroupId | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| BankDeposit | Non-Identifying | One To Zero or More | NO |
| GeneralLedgerReleaseBatch Check Constraints |
| Check Constraint Name | CheckConstraint |